package com.common.www.repository.recycle;


import org.springframework.boot.base.jpa.repository.support.ExtendedRepository;
import com.common.www.bean.entity.recycle.RecycleBillTypeItem;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;


/**
 * Created by luozisong on 2017/8/9.
 */
@Repository
public interface RecycleBillTypeItemRepository extends ExtendedRepository<RecycleBillTypeItem, Long> {

    /**
     * 重新计算时更新推算
     * @param billId
     */
    @Modifying
    @Query(value = " UPDATE recycle_bill_type_item SET flag=0 WHERE parent=:billId",nativeQuery = true)
    void deleteToUpdate(@Param("billId") Long billId);


}
